package com.ibuonline.b2b.admin.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.springframework.jdbc.core.RowMapper;

import com.dimeng.common.base.SuperDAO;
import com.ibuonline.b2b.entity.SeoHotKeywords;

public class HotWordsManageDAO extends SuperDAO<SeoHotKeywords> {
	@SuppressWarnings("unchecked")
	public List<String> getAllHotWords() {
		String sql = "SELECT s.name as hotwordname  FROM seo_hot_keywords s";
		return this.jdbcTemplate.query(sql, new RowMapper() {
			@Override
			public Object mapRow(ResultSet rs, int arg1) throws SQLException {
				return rs.getString("hotwordname");
			}
		});
	}
}
